﻿using System;

namespace edowork.com.Model
{
    #region sellbillInfo

    [Serializable]
    public class sellbillInfo
    {
        #region Private fields

        protected string _sabid = String.Empty;
        protected string _sepid = String.Empty;
        protected string _billtype = String.Empty;
        protected string _billdate = String.Empty;
        protected string _warehouseid = String.Empty;
        protected string _customerid = String.Empty;
        protected string _phone = String.Empty;
        protected string _fax = String.Empty;
        protected string _settleid = String.Empty;
        protected string _period = String.Empty;
        protected string _arrivaldate = String.Empty;
        protected string _marked = String.Empty;
        protected string _statistical = String.Empty;
        protected string _ordercoding = String.Empty;
        protected string _consignee = String.Empty;
        protected string _address = String.Empty;
        protected string _testreport = String.Empty;
        protected string _wayof = String.Empty;
        protected string _payment = String.Empty;
        protected string _arrears = String.Empty;
        protected string _amountDue = String.Empty;
        protected string _extended = String.Empty;
        protected string _solution = String.Empty;
        protected string _notstiff = String.Empty;
        protected string _userid = String.Empty;
        protected string _sysdate = String.Empty;
        protected string _remark = String.Empty;
        protected string _staffID = String.Empty;
        protected string _invoicestu = String.Empty;
        protected string _staffstu = String.Empty;
        protected string _staffremark = String.Empty;
        protected string _checkuserid = String.Empty;
        protected string _checkdate = String.Empty;
        protected string _checkstu = String.Empty;
        protected string _checkremark = String.Empty;
        protected string _m_stu = String.Empty;
        protected string _m_date = String.Empty;
        protected string _m_ID = String.Empty;
        protected string _b_open = String.Empty;

        #endregion

        public sellbillInfo() { }

        #region Public Properties

        public string Sabid
        {
            get { return _sabid; }
            set { _sabid = value; }
        }

        public string Sepid
        {
            get { return _sepid; }
            set { _sepid = value; }
        }

        public string Billtype
        {
            get { return _billtype; }
            set { _billtype = value; }
        }

        public string Billdate
        {
            get { return _billdate; }
            set { _billdate = value; }
        }

        public string Warehouseid
        {
            get { return _warehouseid; }
            set { _warehouseid = value; }
        }

        public string Customerid
        {
            get { return _customerid; }
            set { _customerid = value; }
        }

        public string Phone
        {
            get { return _phone; }
            set { _phone = value; }
        }

        public string Fax
        {
            get { return _fax; }
            set { _fax = value; }
        }

        public string Settleid
        {
            get { return _settleid; }
            set { _settleid = value; }
        }

        public string Period
        {
            get { return _period; }
            set { _period = value; }
        }

        public string Arrivaldate
        {
            get { return _arrivaldate; }
            set { _arrivaldate = value; }
        }

        public string Marked
        {
            get { return _marked; }
            set { _marked = value; }
        }

        public string Statistical
        {
            get { return _statistical; }
            set { _statistical = value; }
        }

        public string Ordercoding
        {
            get { return _ordercoding; }
            set { _ordercoding = value; }
        }

        public string Consignee
        {
            get { return _consignee; }
            set { _consignee = value; }
        }

        public string Address
        {
            get { return _address; }
            set { _address = value; }
        }

        public string Testreport
        {
            get { return _testreport; }
            set { _testreport = value; }
        }

        public string Wayof
        {
            get { return _wayof; }
            set { _wayof = value; }
        }

        public string Payment
        {
            get { return _payment; }
            set { _payment = value; }
        }

        public string Arrears
        {
            get { return _arrears; }
            set { _arrears = value; }
        }

        public string AmountDue
        {
            get { return _amountDue; }
            set { _amountDue = value; }
        }

        public string Extended
        {
            get { return _extended; }
            set { _extended = value; }
        }

        public string Solution
        {
            get { return _solution; }
            set { _solution = value; }
        }

        public string Notstiff
        {
            get { return _notstiff; }
            set { _notstiff = value; }
        }

        public string Userid
        {
            get { return _userid; }
            set { _userid = value; }
        }

        public string Sysdate
        {
            get { return _sysdate; }
            set { _sysdate = value; }
        }

        public string Remark
        {
            get { return _remark; }
            set { _remark = value; }
        }

        public string StaffID
        {
            get { return _staffID; }
            set { _staffID = value; }
        }

        public string Invoicestu
        {
            get { return _invoicestu; }
            set { _invoicestu = value; }
        }

        public string Staffstu
        {
            get { return _staffstu; }
            set { _staffstu = value; }
        }

        public string Staffremark
        {
            get { return _staffremark; }
            set { _staffremark = value; }
        }

        public string Checkuserid
        {
            get { return _checkuserid; }
            set { _checkuserid = value; }
        }

        public string Checkdate
        {
            get { return _checkdate; }
            set { _checkdate = value; }
        }

        public string Checkstu
        {
            get { return _checkstu; }
            set { _checkstu = value; }
        }

        public string Checkremark
        {
            get { return _checkremark; }
            set { _checkremark = value; }
        }

        public string M_stu
        {
            get { return _m_stu; }
            set { _m_stu = value; }
        }

        public string M_date
        {
            get { return _m_date; }
            set { _m_date = value; }
        }

        public string M_ID
        {
            get { return _m_ID; }
            set { _m_ID = value; }
        }

        public string B_open
        {
            get { return _b_open; }
            set { _b_open = value; }
        }

        #endregion

        #region Public SQL Script

        public string SQL_Insert()
        {
            return "insert into sellbill(Sabid,Sepid,Billtype,Billdate,Warehouseid,Customerid,Phone,Fax,Settleid,Period,Arrivaldate,Marked,Statistical,Ordercoding,Consignee,Address,Testreport,Wayof,Payment,Arrears,AmountDue,Extended,Solution,Notstiff,Userid,Sysdate,Remark,StaffID,Invoicestu,Staffstu,Staffremark,Checkuserid,Checkdate,Checkstu,Checkremark,M_stu,M_date,M_ID,B_open) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}','{25}','{26}','{27}','{28}','{29}','{30}','{31}','{32}','{33}','{34}','{35}','{36}','{37}','{38}')";
        }

        #endregion

    }

    #endregion
}

